Stored Procedures [dbo].[asi_SequencePeek]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@SequenceNamenvarchar(30)60
SQL Script
CREATE PROCEDURE [dbo].[asi_SequencePeek]
    @SequenceName nvarchar(30) AS

SELECT CurrentValue FROM SequenceCounter WHERE CounterName = @SequenceName

GO
Uses